Upgrading external tables to SQL Server Compact Edition

Beginning with TeamWork 2010, the external databases (user accounts, Local Workspace, and lookup tables, if applicable) that are created and maintained by 64-bit components store the data in SQL Server Compact Edition instead of in Microsoft Access databases as in the previous versions. This is necessary because no 64-bit OLEDB driver for Microsoft Access is provided with Windows. When upgrading TeamWork from 32-bit to 64-bit components, these databases must be converted manually if no 64-bit OLEDB driver is installed. The upgrade will not overwrite the existing registry settings for Microsoft Access usage, they must be changed manually. The settings that must be changed are listed in Recommended server specifications.

We recommend that new TeamWork 64-bit installations use SQL Server Compact Edition and convert any existing Access databases using the following instructions. Existing installations may either install the 2010 Office System Driver and continue to maintain the databases in Microsoft Access format or convert existing Access databases to SQL Server Compact Edition using the following instructions.

Note The 64-bit TeamWork Configurator application cannot create tables in Microsoft Access format or add entries to the tables. Install and use the 32-bit TeamWork Configurator instead if external tables in Microsoft Access format are required.

To convert the Microsoft Access databases to SQL Server Compact Edition:

• Use the program BlueCieloECM.MdbToSdfConvertor.exe located in the TeamWork Program folder.

To convert a lookup tables database:

• Run the following in the \BC-TeamWork Extensions\<VaultName> folder:

<PathToProgramFolder>\BlueCieloECM.MdbToSdfConvertor.exe <VaultName>$LL.mdb -TTAB [-S[ql]]

To convert a user accounts database:

• Run the following in the \BC-TeamWork Vaults folder:

<PathToProgramFolder>\BlueCieloECM.MdbToSdfConvertor.exe ICUserDB.mdb -TUDB [-S[ql]]

To convert a local workspace database:

• Run the following in the \BC-WorkSpace\<UserName>\<VaultContext>\__$$Environment folder:

<PathToProgramFolder>\BlueCieloECM.MdbToSdfConvertor.exe __$$Vault.mdb -TLWS -PAMSupport [-S[ql]]

To convert any other database:

• Run the following in the folder containing the database:

<PathToProgramFolder>\BlueCieloECM.MdbToSdfConvertor.exe <DBName>.mdb -TGEN [-P<DBPassword>] [-S[ql]]

Note     The optional [-S[ql]] parameter is for debugging or informational purposes only. It can be specified as -S or as -Sql and will display the output of the SQL statements that are executed.